Tabela EventSession

Definicja tabeli EventSession

Name

EventSession

Code

EventSession

Comment

 


Lista kolumn tabeli EventSession

Name

Code

EventSessionID

EventSessionID

FullName

FullName

ShortName

ShortName

PerfDate

PerfDate

ExternalSessionID

ExternalSessionID

StopDT

StopDT


Kolumna EventSessionID tabeli EventSession

Definicja kolumny EventSessionID tabeli EventSession

Name

EventSessionID

Code

EventSessionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna FullName tabeli EventSession

Definicja kolumny FullName tabeli EventSession

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ShortName tabeli EventSession

Definicja kolumny ShortName tabeli EventSession

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna PerfDate tabeli EventSession

Definicja kolumny PerfDate tabeli EventSession

Name

PerfDate

Code

PerfDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ExternalSessionID tabeli EventSession

Definicja kolumny ExternalSessionID tabeli EventSession

Name

ExternalSessionID

Code

ExternalSessionID

Data Type

VARCHAR2(70)

Mandatory

No

Comment

 


Kolumna StopDT tabeli EventSession

Definicja kolumny StopDT tabeli EventSession

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Data zakonczenia sesji lub cyklu leczenia


Lista kluczy tabeli EventSession

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli EventSession

Definicja klucza Identifier_1 tabeli EventSession

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment